2013-05-30 - 7195.300 - Spec - Rewrite BI FI reports FI112 and FI113 #CrystalReportDevelopment

SPECIFICATIONS

7195.300 - Rewrite BI FI reports FI112 and FI113

Requirement Summary

FI112 Report was developed based on SAP ECC Tables. We need to Rewrite that report based on SAP BEx Queries.

Admin Info

Purpose	Rewrite FI reports FI112 and FI113 based on BW Sources
Requested By	Lori Miterko
Spec Created By	Naga Brahmam R
Spec Created Date	05/30/2013
Spec QA by	Uday Kumar P
Objects	FI112 and FI113
Document Status	Complete

References

Prior Tickets

7195.200
7195.400

Documents

FI112 Income Statement with Last Year-v1 2.docx

Functional Requirement

Overview:
FI112 is an Income Statement Report grouped by Region and includes two portions:
1. The top half of the report should show Income Statement with comparison of this Year Actual vs. Budget.
2. The bottom half of the report should show the Income Statement with comparison of This Year Actual vs. Last Year Actual.
3. All currency in USD only.

Source:
1. FI112 should be sourced from BW; this includes the Company code, GL account, GL description, GL account hierarchy and amount.
2. The only manipulation within Crystal should be for Positive/Negative signs, some calculated fields, and the grouping by region.
3. Please refer to the current FI112 report for formatting.

Grouping of company codes into Regions:
1. Company codes '0010','0011','0014','0020','0021','0100','0074' falls under ‘North America’.
2. Company codes ‘0030’,'0040','0042' fall under ‘EMEA’.
3. Company code ‘0060’ is ‘Japan’.
4. Company codes '0026','0028','0050','0055','0058' fall under ‘Emerging’.
5. All others fall under ‘New Era LLCs’

Parameters:
1. Period Range (starts and end).
2. Watermark (Preliminary Final).
3. Fiscal Year (ex. 2013).

Drill Down:
Fields on the left of the report can be drilled down to the company codes within the reports region.
Positive/Negative sign:
Because SAP stores Credit balances as Negative and Debit balances as positive, for the purpose of reporting, formatting for each of the reports items need to be taken into consideration:
1. Sales Net: SAP credit balance should appear on the report as positive value, SAP debit amount should appear as negative value.
2. Cost of goods sold: SAP credit balance should appear on the report as negative value, SAP debit amount should appear as positive value.
3. Selling and Distribution expense: SAP credit balance should appear on the report as negative value, SAP debit amount should appear as positive value.
4. Other income(expense): credit balance should appear on the report as positive value, SAP debit amount should appear as negative value.

Top Portion of the Report: Calculated fields:
1. Gross Profit = Sales Net – Cost of goods sold.
2. Operating Profit = Gross Profit – Selling and distribution expenses.
3. Income Before Provision for Taxes = Operating Profit + Other income (expense).
4. Variance (This year vs. Budget): = Actual – Budget.
5. Variance % (This year vs. Budget): = (Variance/Budget)*100%.

Top Portion of the Report: Calculated fields:
1. Gross Profit = Sales Net – Cost of goods sold.
2. Operating Profit = Gross Profit – Selling and distribution expenses.
3. Income Before Provision for Taxes = Operating Profit + Other income (expense).
4. Variance (This year vs. Budget): = Actual – Budget.
5. Variance % (This year vs. Budget): = (Variance/Budget)*100%.
6. Variance (This year vs. Last Year): = Actual – Last Year.
7. Variance % (This year vs. Last Year): = (Variance/Last Year)*100%.

GL Hierachy:
1. GL hierarchy can be found in ECC Tcode OB58.
2. Financial Statement Version 0010, the portion under “Profit & Loss Statement”.
3. Only below items should be included in FI reports:

Sales Net.
Cost of Goods Sold.
Selling and distribution expenses.
Other Income(expense).

Solution Summary

Need to recreate FI112 Report based on SAP BEx Query.

Test Plan

SNo	Test Scenario	Expected Results
1	Compare the old FI112 report values with newly developed report.	Both report values should be matching.

Solution Details

1. Need to recreate FI112 report based on SAP BEx Query with same structure of as that of previous report.
2. Apply the same Groups and Hierarchy values for the report.
3. Validate both reports and notify NEC if successful.

Issues

None